﻿CREATE PROCEDURE [dbo].[Address_Update]
@AddressID uniqueidentifier
, @ModifiedBy uniqueidentifier
, @ProvinceID uniqueidentifier
, @Line1 varchar (64)
, @Line2 varchar (64)
, @Suburb varchar (64)
, @Code varchar (12)
, @Longitude numeric (18,18)
, @Latitude numeric (18,18)
AS
BEGIN

UPDATE [dbo].[Address]
SET  [ModifiedBy] = @ModifiedBy
, [ProvinceID] = @ProvinceID
, [Line1] = @Line1
, [Line2] = @Line2
, [Suburb] = @Suburb
, [Code] = @Code
, [Longitude] = @Longitude
, [Latitude] = @Latitude
, [ModifiedDate] = GETDATE()
WHERE [Deleted] = 0
AND [AddressID] = @AddressID


END
